package com.byxm.wlgw.query;

public class YhxxQuery extends BaseQuery {

	public YhxxQuery(String sTableNm) {
		super(sTableNm);
	}
	/**
	 * 插入邮箱和密码
	 */
	public String getInsertYhxx(String email,String yhmm){
		StringBuffer sql = new StringBuffer();
		sql.append("insert into yhxx (email,yhmm)values( ");
		sql.append("'"+email+"',");
		sql.append("'"+yhmm+"')");
		return sql.toString();
	}
	/**
	 * 匹配用户名邮箱和密码
	 */
	public String getYhxxValidate(String email,String yhmm){
		StringBuffer sql = new StringBuffer();
		sql.append("select * from yhxx where email='" ).append(email).append("'");
		sql.append(" and yhmm='").append(yhmm).append("'");
		return sql.toString();
	}
}

